SELECT T.* FROM C1_DICTIONARY T WHERE t.type_code = :typeCode
order by t.ORDER_NUM
